﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using PACS.Data;
using System.Data;

namespace WoSoft.PACS.Data.BaseData
{
    /// <summary>
    /// 系统编码管理
    /// </summary>
    public class SystemCode : Db
    {
        /// <summary>
        /// 分类ID
        /// </summary>
        /// <returns></returns>
        public DataTable GetCodeList(int cid)
        { 
            var dt = SqlDatabase.Sql("select * from 编码值 where 分类ID=" + cid, null).QuerySingle<DataTable>();
            return dt;
        }

        //加载职业 
        public DataTable GetWorkerList()
        {
            var dt = SqlDatabase.Sql("select * from 职业", null).QuerySingle<DataTable>();
            return dt;
        }

    }
}
